Previous topicNext topic
 Link Technologies - LinkSOFT Documentation 
Help > Link Web Applications Portal > Global Administration >
Database Backup

Database Backup is used to create and maintain backup files.

  1. Users can create a manual backup:
    1. Before updating a pay .
    2. Before processing "End of Year"
    3. Backup database for upgrade.
  2. Automatic backups are created by “Process SYS003 - Database backup. Removes old backups based on retention days".

Notes

  1. The backups are created by the background process “SYS001 - Server process used to prepare alerts and complex computation."
  2. The backup is created as :
    1. A "Full" database backup.
    2. The backup "Compression " is based on the SQL Server defaults.
  3. If the configured backup path is not found, the backup will created in the SQL Server default path.
    1. Do not use the "Operating System" or the "Data" drive (where SQL data files are stored) for backup.
    2. If "Data" drive is full, the SQL server will go into "Read Only" mode and updates in the system will be terminated due to lack of space.
  4. Upload a copy of the backup to the Link FTP  (Free Service) as secondary backup.
  5. Red entry indicates that the backup is incomplete . The backups are created when the entries are marked as “Completed”.

Step to create Backups

  1. Add a New Record
  2. Enter the "Description" for the backup.
  3. Enter the "Retention Days"
    1. This is the number of days after which the backup file is deleted. This limits disk usage so it does not get full.
    2. The Database Administrator should take a copy of the backup before it is deleted.
  4. FTP Upload - Tick this option to upload the backup to "Link Technologies Secure FTP". FTP Upload is done by the process "Maintenance tasks used to cleanup temporary files and perform system tasks such as "FTP Upload" to Link Technologies Backup Repository." in menu "Global Administration -> Process Setup "

Figure 1 : Database Backup


Figure 2: FTP Backups